论坛精华
>> Oracle 专栏
>> A 7-18 Starting to Analyze the redo log files [查看别人的评论]
由 macro 发布于: 2001-03-04 15:53
Initialize a LogMiner session:
EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME=>'C:\ora815\oradata\v815\log\v815dict.ora');
Tracking Changes to a table
eg.
SELECT timestamp,username,sql_redo FROM v$logmnr_contents WHERE seg_name='EMP';
Finish the logMiner session:
EXECUTE DBMS_LOGMNR.END_LOGMNR;
Obtaining Information About Logs Being Analyzed
Once LogMiner has been started ,the following data dictionary views can be used:
1.v$logmnr_dicationary
2.v$logmnr_parameters
3.v$logmnr_contents
__________________
谢谢你抽时间看我的发言，
Macro Zeng
==================================
我正在学习 Oracle ,坚持每天写读书笔记
|
